Get ready for the Class 10 ICT Chapter 1: Digital Literacy Test 2, specially designed for students of the Computer Science and Entrepreneurship Tech Group. This full unit test covers important concepts of Information and Communication Technology (ICT) according to the new syllabus issued by PECTAA Punjab for the Punjab Board Annual Examination 2027. This Class 10 ICT chapter-wise test series helps students evaluate their subject knowledge, practise important questions, strengthen their understanding of digital literacy, and improve their board examination preparation. Explore our Punjab Board 2027 Model Papers and chapter-wise ICT tests for effective and structured exam preparation.
Information and Communication Technology
Chapter 1: Basic Digital Literacy | Board Standard Paper – Test 2
| Name: ______________________ | Roll No: ____________ | Class: ________ |
| Time: Objective 10 Min | Subjective 1 Hr 45 Min | Total Marks: 40 | |
OBJECTIVETime: 10 Min Marks: 10
| No. | Answer | No. | Answer |
|---|---|---|---|
| 1 | ABCD | 6 | ABCD |
| 2 | ABCD | 7 | ABCD |
| 3 | ABCD | 8 | ABCD |
| 4 | ABCD | 9 | ABCD |
| 5 | ABCD | 10 | ABCD |
NOTE: Four possible answers A, B, C and D are given for each question. Fill the circle of the correct answer with a marker or pen. Cutting or filling two or more circles will score zero in that question.
Q.1: Choose the correct answer. (10 × 1 = 10)
1. The smallest unit in a spreadsheet is a:
(A) Row(B) Column(C) Cell(D) Chart
Correct Answer: C
2. In a spreadsheet, columns are named with:
(A) Letters(B) Numbers(C) Colours(D) Symbols
Correct Answer: A
3. Which function shows the smallest value in a range?
(A) MAX(B) SUM(C) AVERAGE(D) MIN
Correct Answer: D
4. The formula =A1+B1+E1 adds:
(A) All cells from A1 to E1(B) The values of three different cells(C) Only A1 and B1(D) Complete columns A, B and E
Correct Answer: B
5. Which chart shows data as parts of a circle?
(A) Bar chart(B) Line chart(C) Pie chart(D) Table
Correct Answer: C
6. Which shortcut is used to AutoFit the selected column?
(A) Alt + H + O + I(B) Ctrl + Shift + L(C) Ctrl + 1(D) Ctrl + A
Correct Answer: A
7. To create a new file in MS Excel, click File and then select:
(A) Open(B) Save(C) Close(D) New
Correct Answer: D
8. A single spreadsheet can hold:
(A) Only ten rows(B) Thousands of rows and columns(C) Only numbers(D) Only one column
Correct Answer: B
9. Sorting means:
(A) Arranging data in a specific order(B) Hiding unwanted rows(C) Deleting old data(D) Adding borders to cells
Correct Answer: A
10. Which part of a chart tells what the chart is about?
(A) Legend(B) Axis label(C) Gridline(D) Title
Correct Answer: D
Page 1 of 2
www.786Times.com | An Education Project in Punjab
Information and Communication Technology
Chapter 1: Basic Digital Literacy | Subjective
Note: It is compulsory to attempt any four (4) parts each from Q.No.2 and Q.No.3, and any two (2) questions from Part II. Write the same question number and part number as given in the question paper.
SUBJECTIVE – PART IMarks: 16
Q.2: Write short answers to any FOUR parts. (4 × 2 = 8)
- What is data entry? Write two examples of data that can be entered in a spreadsheet.
Ans: Data entry means typing information into the cells of a spreadsheet. We can type numbers, words or formulas. Examples: student names, marks, prices of items.
- Why are rows and columns important in a spreadsheet?
Ans: A row holds all information about one person or item and is useful when many entries are recorded one after another. A column keeps one type of data, such as all names, so data looks organized and is easy to compare. Columns are important for sorting, filtering and calculations.
- Differentiate between =SUM(A1,A5) and =SUM(A1:A5).
Ans:
=SUM(A1,A5) =SUM(A1:A5) Adds only the two cells A1 and A5 Adds all cells from A1 to A5 (a cell range) If A1 to A5 hold 10, 20, 30, 40, 50, the result is 60 For the same values, the result is 150 - How can we use cell values of another sheet in a formula? Give an example.
Ans: We write the sheet name followed by the ! sign before the cell range. Example: =SUM(Sheet2!A1:A5).
- What is the use of the AutoSum button?
Ans: The AutoSum (Σ) button calculates totals in seconds, so no calculator is required.
- What happens to the cell addresses of a formula when it is copied and pasted into another cell?
Ans: The cell addresses in the formula change according to the source and destination addresses.
Q.3: Write short answers to any FOUR parts. (4 × 2 = 8)
- What is a data report? Give one example.
Ans: A data report is a way to present information in an organized form. We enter data, perform calculations, and use charts or tables to make clear reports. Example: teachers prepare reports of students’ marks, and shopkeepers prepare reports of their sales.
- Write any two benefits of sorting data.
Ans: 1) It helps us find information easily and see patterns in the data. 2) Sorted data looks more organized and is easier to understand. (It is also helpful in reports, lists and records where order is important.)
- A teacher has the marks of many students. How can she show only the students who scored above 80?
Ans: She can apply a filter (Ctrl + Shift + L) on the marks column and set the condition to above 80. Only the matching rows are shown. The other rows are hidden, not deleted.
- Which chart is best to show: (a) marks of five students compared, (b) parts of a household budget, (c) sales over a year?
Ans: (a) Bar chart for comparing values. (b) Pie chart for parts of a total. (c) Line chart for changes over time.
- How can the title, labels and legend of a chart be set or changed?
Ans: Select the chart and use the Design tab of the chart tools to set or change the title, labels and legend.
- How can colours and borders make a budget neat and clear?
Ans: Colours and borders can highlight important expenses, or mark savings in a different colour. This makes the budget neat, clear and easy to read.
SUBJECTIVE – PART IIMarks: 14
Attempt any TWO questions. (2 × 7 = 14)
Q.4: What is meant by organizing data? Explain sorting and filtering in detail with examples. (7)
Ans: When we have a lot of data in a spreadsheet, it is hard to find what we need. Sorting and filtering help us work with data quickly and clearly.
- Sorting: arranging data in a specific order. Text can be sorted from A to Z or Z to A, and numbers from smallest to largest or largest to smallest. It helps us find information easily and see patterns. Example: sorting a list of students by their names or marks. It is very helpful in reports, lists and records where order is important.
- Filtering: showing only the data that meets certain conditions. The spreadsheet hides the data we do not need. Example: showing only students who scored above 80 marks. The other rows are hidden, but they are not deleted. Ctrl + Shift + L applies or removes filters, and custom filters can be used on several columns at the same time to narrow down data efficiently.
Q.5: Explain the practical uses of spreadsheets: making a budget plan and creating data reports. (7)
Ans: Spreadsheets are useful in daily life, school and work. People use them to record data, make budgets and prepare reports. They save time and help organize large amounts of information.
- Budget plan: a budget plan helps us manage money wisely. We list all sources of income and all types of expenses, and use formulas to find total income, total spending and the remaining balance. Colours and borders make the budget neat, for example highlighting important expenses or marking savings in a different colour. It helps families and businesses control spending and save money.
- Data reports: a data report presents information in an organized form. We enter data, perform calculations, and use charts or tables to make clear reports that help people understand results and make better decisions. Teachers prepare reports of students’ marks and shopkeepers prepare reports of their sales. Sorting, filtering and charts make reports detailed and easy to read.
Q.6: Explain how formulas and functions work in a spreadsheet. Describe SUM, AVERAGE, MIN and MAX with an example. (7)
Ans: Spreadsheets can do many kinds of calculations automatically. This saves time and reduces errors.
- Formula: to use a formula, we type an equal sign (=) followed by the function name and cell range, such as =SUM(A1:A5). The spreadsheet calculates the answer right away. A formula can also use cell addresses directly, such as =A1+B1+E1.
- Functions: SUM adds numbers, AVERAGE finds the mean, MIN shows the smallest value and MAX shows the largest.
- Useful points: =SUM(A1,A5) and =SUM(A1:A5) give different results. Values of another sheet are used with the ! sign, e.g. =SUM(Sheet2!A1:A5). The AutoSum (Σ) button gives totals in seconds. When a formula is copied and pasted, its cell addresses change according to the source and destination.
| Formula | Result |
|---|---|
| =SUM(A1:A5) | 150 |
| =AVERAGE(A1:A5) | 30 |
| =MIN(A1:A5) | 10 |
| =MAX(A1:A5) | 50 |
Page 2 of 2
www.786Times.com | An Education Project in Punjab
